Skip to main content

Questions tagged [google-sheets-import-csv]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
11 views

Spaces being incorrectly removed from text strings when importing data into Sheets

I have spreadsheet data that I want to import to Google Sheets. The source spreadsheet is a proprietary format; neither Google Sheets nor MS Excel. The issue I'm running into is that I have columns ...
Haris Serdarevic's user avatar
0 votes
1 answer
250 views

How to import only some of csv into Google Sheets [closed]

I'm trying to auto-import this huge csv file into Google Sheets, but when I use the importdata function, it tells me "Resource at URL contents exceeded maximum size." I'd like it to auto-...
Matthew's user avatar
  • 11
0 votes
2 answers
632 views

Using IMPORTDATA with a csv file with different numeric format than locale

I'm using IMPORTDATA to get some Crypto Rates. My Spreadsheet has Locale settings to Spain and the data from the csv have the numeric format of United States, so I'm getting wrong numbers. There's a ...
Juan Antonio Tubío's user avatar
3 votes
3 answers
1k views

File import into sheets is dropping necessary leading spaces

I have a configuration .txt file that I'm trying to upload into a new tab in an existing Google spreadsheet. I choose File>Import and select Insert new sheet(s), Detect automatically (there is no ...
kviLL's user avatar
  • 364
0 votes
2 answers
941 views

Google Sheets interpreting dates from CSV in a weird way

I'm opening a csv report in Google Sheets. The Google Drive preview shows the dates like this: When I open this file in Google Sheets the dates now look like this: And if I try and convert the date ...
Westicle's user avatar
1 vote
2 answers
2k views

Date fields that refuse to be parsed/formatted

I have some very mysterious date fields in a huge (600 000 records) CSV file which absolutely refuses to behave. They come up aligned left, and conditional formatting shows that they cannot be seen ...
Sharkfin's user avatar
0 votes
1 answer
2k views

Import a CSV file to Google Spreadsheets

I am trying to upload a CSV file and importing it to Google Spreadsheets. The file contains the following: hi,hello\r\nwelcome,to\r\npeaceful,world What I expect in the Google spreadsheet is: hi,...
Senduran's user avatar
10 votes
3 answers
7k views

Import CSV, show formatted hyperlinks, =Hyperlink(..,..)

Based on a csv import, I would like to show formatted hyperlinks. There is a formula =HYPERLINK( "www.google.com" ; "Search Google" ) that does this, but is there any way to include this in a csv ...
Jasper Duizendstra's user avatar
2 votes
2 answers
8k views

Is there a way to upload a .csv file to Google Docs using a Google Sheets as a template?

I am generating a .CSV file with an application. I then upload the .CSV file to Google Docs, which creates a Google Docs Spreadsheet which is "plain and white". I then have to manually format the .CSV ...
Edward Tanguay's user avatar