All Questions
Tagged with microsoft-excel csv
495
questions
-1
votes
1
answer
289
views
How to get folder location of file? (Powershell) [closed]
I am using the script below, found on this thread.. I would like to automatically save the Excel file in the same folder as the CSV file, using the same name as the CSV file.
How can I get the ...
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
...
1
vote
1
answer
381
views
Excel is adding = in front of cells containing @ mark when importing from CSV
I'm not sure why, but since a few days ago when I import a .csv it is adding a "=" infront of cells which begin with an @.
It should be like this:
But now it is doing this:
I've compared all ...
0
votes
1
answer
45
views
Unable to apply numeric format to column in moderately large CSV file in Excel
I have a moderately sized CSV file (195,000 rows.) For some reason, when I try to format a column of numbers as currency when opening it in Excel, it does nothing at all. If I edit the file and leave ...
-1
votes
1
answer
2k
views
Create multiple text files that follow a pattern
I want to create hundreds of text files that follow a pattern like this (example):
The book [title] written by [author] is about [description] ...
and the variables will be extracted from a csv ...
1
vote
4
answers
19k
views
Get unique values from a comma separated values in a cell
In excel I have a column (actually multiple columns with ~30K rows) with each cell value looking something like this
7AA914BC, 898B70FB, 898B70FB, 15DD4C5B, 15DD4C5B, 98D2185E, 898BAC48, 98D2185E, ...
0
votes
0
answers
38
views
Can't replace filtered rows/constants
I have a table which has Questions (Column A) and then multiple possible answers associated with each question (Column B). This means that for most questions there are a few blank rows in Column A as ...
1
vote
2
answers
1k
views
Make my Excel parse dates from CSV like everyone else's
For my work, I regularly open data in Excel 365 that comes to me in a weird CSV format that I can't control. Here's an example:
"Call-off","Receiver ext.","Plant","Status","Supplier ext.","UnPt","...
0
votes
1
answer
198
views
Error when importing data from CSV ,"Specific argument was out of the range of valid values"
I've been getting an error when trying to import a csv file as a data source using "from text". I do this all the time but I get this specific error with a specific very large csv file. Obviously, I ...
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 ...
1
vote
1
answer
928
views
convert sql-excel date to recognisable format
I have a large csv file(1.1G) exported from SQL Server. I would like to do data wrangling in python, but I had a few problems doing this. The original csv file dates look like this 00:07.5, 00:08.3, ...
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 ...
2
votes
2
answers
956
views
Why is Unicode 1200 codepage not there in excel?
I am opening a CSV file which is created with Unicode 1200 codepage but when I bring up the wizard in excel to open it, this codepage is not there. I only see UTF-7 and UTF-8.
I do need to open an ...
0
votes
1
answer
882
views
How to export/update CSV file through Excel Macro?
Thanks in advance for any help!
I have a file that produces an output table that also contains a unique key for the set of data. I want to be able to export this data into a CSV file.
That is easy ...
3
votes
3
answers
7k
views
Combine multiple CSV files by column, not by row
I have ~100 CSV files that I want to combine into one single Excel spreadsheet (everything in one tab, not in separate tabs). These CSV files are identical in format: each contains 4,000 rows and 2 ...
0
votes
0
answers
657
views
How to change a file's encoding?
I am not sure if the question is the right one for my situation, but here is what I want to do:
I've downloaded a .csv file with Chinese characters in it. When opened with MS Excel, the Chinese ...
0
votes
2
answers
302
views
Changing the structure of csv data
I'm trying to change data looking like this:
original csv
into this format:
name = "The V Girl";
author = "Mya Robarts";
pages = 341;
imageURL = "https://i.gr-assets.com/images/S/compressed.photo....
3
votes
2
answers
2k
views
Excel Power Query Load Times - Why do dependent queries reload CSV file data?
I have a series of queries in Excel which all depend on an initial query which loads data from CSV files, processes them and loads them into a table in the worksheet. The remaining queries all use ...
0
votes
0
answers
973
views
CSV exported as comma separated and decimal separator is CSV
I have a problem, where i exported some large csv files, and after some time the separator jumped back to default comma, but the problem is that the decimal separator of the software (SQL Developer) ...
0
votes
1
answer
428
views
How do I prevent Excel from appending extra “” marks when I convert the excel file to a CSV file?
I am currently using =concatenate() to wrap all my fields in "" so that it is easier for me to parse in JavaScript after I convert the file to CSV.
The problem is that the actual value in excel is "...
0
votes
0
answers
124
views
I have a CSV file that has 3 column. Need help to format correctly via SQL SSIS Import
I have an CSV file being dropped to a file location once a day. When SSIS picks it up it's failing due to format issue since it has 3 columns and not delimited with 1 column.
Can someone help me ...
0
votes
1
answer
40
views
Excel 2013 showing only certain dates in a European format
I have a CSV file where all dates are in a U.S. format (dd/mm/yyyy):
However, Excel shows some - but not all - of the cells in mm.dd.yyyy format:
This is on a server in Germany.
Does anyone know ...
3
votes
4
answers
7k
views
Create a CSV file with leading zeros which Excel never removes
We all know Excel's annoying behavior of removing leading zeros from imported CSV files
I am a developer and I'd like to program an export feature that creates a CSV file that forces Excel to keep ...
1
vote
1
answer
148
views
Certain Time Values in a .xlsx not Changing When I convert to a .csv
I am trying to convert from an Excel spreadsheet (.xlsx) file to a .csv file. The software I am using is Excel 2007. The issue I am having is I have a column of date and time values for every hour of ...
0
votes
1
answer
460
views
Automatically assign tasks to other users when importing from Excel
I am trying to automatically assign tasks imported from an Excel spreadsheet to other users. The problem I'm facing is that tasks that I import from a CSV are created for me, and I then have to ...
0
votes
0
answers
196
views
Excel for MacOS drops decimal separators when importing csv file
I regularly work with csv files that use semicolons as the separator when I import these into Excel the decimal points are lost.
The values are displayed with the decimal place in the import wizard ...
0
votes
0
answers
3k
views
After editing CSV file, size increases
i'm trying to edit an CSV file. The main CSV file is 2.466KB after i downloaded it.
After i increased all Prices in one Collumn, and saved it as an .CSV file, the file size increased to 51,252MB.
I ...
0
votes
0
answers
164
views
How to export excel file to csv file without the semicolon outside the inserted values?
I have inserted values into excel file in "order_status" sheet. These values are shown in below picture:
In this sheet I added data validations like: dynamic drop down list, checking if in cell is ...
0
votes
1
answer
1k
views
Export Excel (.xlsx) file to CSV separated with commas
I am using Microsoft Office 365 ProPlus. When I save my document as CSV, I end up with values separated with semi-colons, but I really need commas.
I tried changing Windows Regional Settings to put ...
0
votes
2
answers
4k
views
CSV File doesn't look like a table
I have downloaded a csv file, and when I open it in excel, it looks like the image below.
I would like to view the data in a table format. with each field in a separate column.
0
votes
1
answer
48
views
Filter a set of data to a specific number of characters before and after a searchword // JSON,CSV
I have the problem that I have to deal with a set of data given in a JSON/CSV file. I am having four items per entry and one of them has ±5000 characters. I need only a certain range of information ...
1
vote
1
answer
2k
views
Dates appear as ### in CSV file
We currently will be switching from one software to another for our licensing/permitting. When I export our data into an excel CSV file from our software, columns with dates (exp. dates, date record ...
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 ...
0
votes
0
answers
286
views
How to automatically use "From Text/CSV" when opening .csv file in Excel
When opening a CSV file in Excel the normal way it works ok, but the way it displays the data is lackluster. I recently discovered that under the "Data" tab there is a button "From Text/CSV". When you ...
1
vote
2
answers
5k
views
How to use values from imported CSV in Excel formulas?
I have an Excel 2016 spreadsheet that uses a CSV file as a data source. I would like to use conditional formatting and formulas to visualize that data more easily.
The problem is that formulas and ...
-2
votes
1
answer
121
views
Messed up CSV file
I was trying to open a CSV file that was in an APK, but the text came up all messed up. I don't know if this is an encoding issue, an encryption or to do with the fact that I changed the .apk file ...
2
votes
2
answers
6k
views
Convert comma delimited, key-value pairs in single column into different columns
I have a column in an excel sheet that contains value formatted like the following:
"Key1":"Value1","Key2":"Value2","Key3":"Value3"..
I have many rows of this data. I would like to break these keys ...
0
votes
1
answer
401
views
Excel, importing incomplete data to a complete table?
I'm not sure if I'm asking this correctly, but here's my problem.
I'm managing the occupancy of a building, and the website we use lets us generate a report of the occupants by room. This information ...
0
votes
1
answer
2k
views
Why does my exported CSV data get converted to weird formats?
I am using Microsoft Office 2007. I have an Excel file and need to convert it into a CSV File. When I save the file as CSV then some values are converted into another format
Before converting the 4th ...
1
vote
1
answer
259
views
How to sort number of numeric columns in one go
I have 350 columns. Below is a subset of all the data.
I used "Sort Smallest to Largest" tool. It gives results only for one column. If not, it can sort the first column and other columns will ...
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 ...
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,...
2
votes
2
answers
6k
views
Limiting the number of rows imported into Excel from a large CSV file
I have a large CSV file with approximately 70,000,000 rows. I have read how to import it into Excel as a data model and then pivot table here. Is there a way in Excel to just load a certain number of ...
0
votes
1
answer
4k
views
Deleting rows in Excel using powershell
I have a csv file which has a series of pin-codes in column A but the first row/cell (A1) is empty and I need to delete the whole row using Powershell,
any ideas?
I have tried this but it did nothing!...
0
votes
0
answers
2k
views
CSV file with headers for office 365 migration
I am using the CSV file with headers only template from microsoft to import multiple users in the migration wizard for Office 365 Exchange Online...however once populated and saved.
When i verify on ...
9
votes
3
answers
37k
views
Excel 2019 not opening CSV correctly - not parsing columns
When I open a CSV files in Excel 2019 the file is not being parsed correctly. When I opened the same files in Excel 2016 they would be parsed correctly, with the commas used as delimiters. But I have ...
0
votes
1
answer
30
views
Mail Merge with formatting alters data
When I perform a mail merge with no formatting (the Merge Field being "MERGEFIELD Cycle1Subject1StudentPercentage"), the answer that appears is correct "52.33"
However, if I do it using a formatting ...
0
votes
3
answers
2k
views
Remove hyperlink text from csv
I have a csv file (created in excel file) whose first 2 lines are somehow like this:
"=HYPERLINK(""https://some.url/browse/ISSUE-3146"", ""ISSUE-3146"")","Bug","Related Case : Some description ",0.0,...
0
votes
0
answers
181
views
Multiple excel data copy into one excel
I have multiple CSV file data i need to copy all CSV data into one excel based on the cell value Like
Source excel sheet1 B2:C2 to till end row data i need to copy Target Excel Sheet3 Column B2:C2 ...
0
votes
1
answer
76
views
Excel: how to import identically formatted CSV files
Apologies if this has been asked and answered before - I have looked but not found.
I get CSV files every two weeks that are identically structured, and I need to import them to the same Excel 2016 ...