All Questions
Tagged with microsoft-excel csv
141
questions with no upvoted or accepted answers
3
votes
0
answers
1k
views
When importing CSVs, does Excel have a limit of 32,767 characters or 32,758 characters?
According to the documentation, Excel has a limit of 32,767 characters per cell.
However, when I save a CSV file that looks like this:
"Cell with exactly 32,767 characters........","...
- 845
3
votes
0
answers
117
views
Excel csv-import into table referenced by name
I have a worksheet called raw_data where I import some data via the Data-Import Wizard. This created a new name-referenced range called abc.csv.
However if I try to create a table on another ...
3
votes
2
answers
10k
views
Formatting date in excel for csv upload
I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy.
Is there a way to ...
- 131
3
votes
0
answers
775
views
How to setup a CSV web datasource
In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...
- 583
2
votes
0
answers
872
views
Loading UTF8 CSV files generated on a Mac into Excel on Windows: does not recognize encoding
When I generate a UTF8 CSV file in Excel (or some other way) on Windows and then open it n Excel, I expect it to ask me to choose the right encoding.
I got a UTF8 CSV file that was generated on a Mac. ...
- 489
2
votes
0
answers
713
views
Open Colon delimited file from command line in Excel
I want to create a shortcut or a command to open a file that uses a colon : as a delimiter in excel.
I know via the UI I can
click "From Text/CSV"
select a file
click Import
select a ...
- 121
2
votes
0
answers
42
views
Import csv file in excel scrambles characters
I'm trying to import a csv file that I created myself out of a python script. I'm struggling with encoding. The csv file is encoded in utf-8 with unix style line endings. TI"m on a german macos ...
- 151
2
votes
0
answers
2k
views
Is it possible to make Excel auto-filter case sensitive?
I have a CSV file I opened with Excel 2013 because I wanted to find errors in a specific column.
Here is an extract of data:
"ID";"LANGUAGE";"TYPE";"NAME";"ACTIVE";"CITY";"POSTAL_CODE";"...
- 753
2
votes
1
answer
18k
views
Default character encoding for Excel Text Wizard?
A large part of my job is to run an SQL query, save the results as a UFT-8 encoded csv file then import it into Excel for further manipulation and distribution.
When I import the csv file into Excel ...
- 21
2
votes
1
answer
830
views
How to specify semi colon character ';' as a line ending character when importing CSV to Excel on Mac
(Using Microsoft Excel form Mac version 15.18)
Can see delimiters for the columns in the import steps, but no-where is there an option for defining what the line ending character is.
I need this so ...
- 4,140
2
votes
0
answers
2k
views
Get rid of warning for external data connection
In Excel 2011 for Mac, I'm using an external data link to collect data from a CSV file generated by a third party application. The CSV is continuously filled, so I want to update the data every time I ...
- 727
2
votes
1
answer
650
views
read excel sheet into jagged array
I am a programmer but recently new to both powershell and vba. I found this simple but effective command in powershell to read in a csv file and you can then immediately access "columns" by their ...
- 41
2
votes
1
answer
15k
views
How to automatically import data from csv file and append to existing Excel table
I have a .csv file and a master excel file. The master file contains a table and I would like to automatically append the data in the .csv file to the existing table. The data has the same headers and ...
- 31
2
votes
1
answer
937
views
How to output a CSV file from a matrix of Excel formulas using multiple files?
I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...
- 121
2
votes
3
answers
3k
views
Change line endings and delimiter format (permanently) when saving to CSV from Excel
I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to ","
Is there ...
- 83
2
votes
2
answers
7k
views
How can I convert PDF bank statements to a Excel or CSV file?
I am just doing my UK tax return (Yes I have left it until the last minute). My bank (Nationwide) will only let me download the last 15 months of transactions as a CSV file, but will let me download ...
- 1,341
1
vote
1
answer
752
views
Change encoding to Unicode in .csv exported from Gmail
I'd like to copy the typed-in addresses from Gmail to Outlook 2021 (Windows 10).
To do this, I'm using the Google Contacts Export to Outlook CSV function and nk2edit.
The problem is that the special ...
1
vote
1
answer
1k
views
Excel - CSV file formats Date column in different ways
I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table.
The problem I am facing is that the date ...
- 11
1
vote
2
answers
2k
views
Export Excel sheet as CSV, with regional settings
I want to export an excel sheet as CSV, with powershell. The issue I have is that the regional settings are not respected. They say to use semicolon as delimiter, but comma is used instead. If I ...
- 194
1
vote
0
answers
667
views
Use Microsoft Excel to import and refresh data from only some columns of a CSV
I have a CSV that's 100+ MB, so it takes a long time to load.
In Microsoft Excel for Mac Version 16, I'd like to use the "Get data" or a similar functionality to load data from that CSV into ...
1
vote
0
answers
252
views
Concatenate dynamic date time with text in CSV file
Requirement: I have an excel file (a CSV) having a column - "Error -today's date & Time" (now()) to be picked every time Windows Task Scheduler batch file is picking this file. The ...
- 111
1
vote
1
answer
374
views
Why MS Excel doesnt render CSV file correctly
I have a CSV file with following contents:
timestamp, post_header, post_content
2021-12-05 16:11:31.138993,Pista Software | Test,"...<long multiline text>..."
2021-12-05 16:11:31....
- 123
1
vote
0
answers
197
views
Jira -- export tempo timesheet (grid view) to Excel
Jira: How do you export tempo timesheet (grid view) to Excel -- either .csv or an ordinary excel file.
I am using Microsoft Edge browser, and there is no easy link available (such as Export).
I ...
- 243
1
vote
0
answers
300
views
Excel intermittently opens blank excel and CSV files
I have a python script that reads info from MongoDB into a file. It can output either Excel or CSV files.
For some reason when I open the files it either opens as a blank document or showing the ...
- 155
1
vote
0
answers
632
views
Automating Excel to save file as CSV and run live updates
For starters - I am raw and have limited skills, thus the guidance here is important to me.
We have to supply data to a 3rd party in CSV format. The data must be updated at frequent intervals with a ...
- 11
1
vote
0
answers
5k
views
Loading new data from a CSV file into an Excel table
I have an Excel spreadsheet which I made by
starting with a CSV file
converting the data into a table
adding some columns to the table in which various computations happen
saving the file as .xlsx
...
- 173
1
vote
0
answers
184
views
Excel - Manual Column(s) Beside Imported Data
In excel, how do you properly mix 'manual' data and imported data in a sheet / data range?
Requirement
For context, my particular use case is a sort of bare-bones data "triage" tool in excel.
Ideal ...
- 11
1
vote
0
answers
1k
views
Why does a .csv file lose kilobytes when it is saved as the same file, just under a different name?
I had a .csv file called "removed.csv" whose size was 3,959kb, but when I saved it under a different name, "uncleaned_df.csv", its size suddenly became 3,784kb. I've verified that I haven't changed ...
- 11
1
vote
2
answers
3k
views
Splitting a xlsx/csv file based on column value
I'm aware this question has been asked previously, but I've had no luck with previous answers. My spreadsheet has around 30000 total lines.
My spreadsheet is formatted like this:
Name,colour,...
- 11
1
vote
2
answers
7k
views
How to I export filenames, filepath and properties of a directory tree to CSV?
I have a hard drive full of backups that I need to detail on a spreadsheet quickly and in the following specific way. I'm hoping there's an easy way to do what i need via some sort of .bat or .cmd ...
- 1,303