Help

Re: Filesize trouble importing Excel sheet

Solved
Jump to Solution
881 0
cancel
Showing results for 
Search instead for 
Did you mean: 
JohnDoe
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, using the Free version I'm trying to import a  15MB Excel sheet into an existing base with four tables (3-6 records per table) but I get the following message:

"testfile.xlsx exceeds maximum allowed size of 5 MB"

I assume this is a limit of the Free version? If so; what are the filesize limits of Team and Business versions?

1 Solution

Accepted Solutions
Alexey_Gusev
13 - Mars
13 - Mars

Hi,
nope, it's import limit. 
how many lines is in your file?
I recently imported (breaking by parts) 10-12 MB file with 50k records.
It seems like you are trying to put into Free base something much bigger than it can contain

See Solution in Thread

4 Replies 4
Alexey_Gusev
13 - Mars
13 - Mars

Hi,
nope, it's import limit. 
how many lines is in your file?
I recently imported (breaking by parts) 10-12 MB file with 50k records.
It seems like you are trying to put into Free base something much bigger than it can contain

JohnDoe
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks! Kinda strange with such a low import limit but I guess there's a reason for it.

automatron3k
4 - Data Explorer
4 - Data Explorer

Hi there, I'm struggling with the same issue here,

I have a large excelsheet with 143K rows (and around 10 columns each), I can't add them neither thru CSV or .XLSX as in both cases the file exceeds the 5 MB limit...

Any workaround?

Hi,
the solution is the same - split by parts and load one by one
notice which part of your file less than 5 Mb, for example if your 143k rows file size is 14 Mb,
then 10k rows is ~1 Mb
copy-paste rows 1-39999 to file01.csv text file (create new file, set name, open with notepad)
then 40000-79999 to file02.csv etc..

I did that by hand, but then tried to make a script
unfortunately, when I tried to write script in VBA, it always produces error, record macro also screwed up, as you can't save selected cells. And Google sheets Script even worse in the terms of usability.
Another moment to praise Airtable scripting extension, which is a great sandbox to learn scripting.

Fortunately, I found an even simpler solution: this CMD script will split the CSV file into parts with a specified number of rows. All you need to do is substitute the required number of rows and your file name.

(Create new text file, paste script there, save as .CMD file, run)

@Echo Off
SetLocal enabledelayedexpansion
Set list=YOUR_FILE.csv
:: number of rows
Set str=20000

Set Num=%str%& Set File=0
For /F "tokens=* usebackq delims=" %%i In ("%list%") Do (
	Set /a Num+=1
	If !Num! GEQ %str% (
		Set Num=0
		Set /a File+=1
		Set nFile=0!File!
		Set nFile=!nFile:~-2!
		Echo %%i>list!nFile!.txt
	) Else Echo %%i>>list!nFile!.txt
)
Pause
Exit